home *** CD-ROM | disk | FTP | other *** search
/ Magnum One / Magnum One (Mid-American Digital) (Disc Manufacturing).iso / d16 / winsql.arc / EXAMPLES.ARC / QUERY11.SQL < prev    next >
Encoding:
Text File  |  1991-06-02  |  88 b   |  2 lines

  1. select sname from s where exists
  2.   (select * from sp where sno = s.sno and pno = 'P2');